--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION.

--##SECTION BEGIN [INTERNAL STORED PROCS]

--This SQL is generated for internal stored procedures for table [actor]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_actor_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_actor_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_actor_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_actor_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_actor_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_actor_Update]
GO

--This SQL is generated for internal stored procedures for table [address]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_address_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_address_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_address_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_address_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_address_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_address_Update]
GO

--This SQL is generated for internal stored procedures for table [category]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_category_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_category_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_category_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_category_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_category_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_category_Update]
GO

--This SQL is generated for internal stored procedures for table [city]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_city_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_city_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_city_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_city_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_city_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_city_Update]
GO

--This SQL is generated for internal stored procedures for table [country]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_country_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_country_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_country_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_country_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_country_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_country_Update]
GO

--This SQL is generated for internal stored procedures for table [customer]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_customer_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_customer_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_customer_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_customer_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_customer_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_customer_Update]
GO

--This SQL is generated for internal stored procedures for table [film]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_Update]
GO

--This SQL is generated for internal stored procedures for table [film_actor]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_actor_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_actor_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_actor_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_actor_Insert]
GO

--This SQL is generated for internal stored procedures for table [film_category]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_category_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_category_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_category_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_category_Insert]
GO

--This SQL is generated for internal stored procedures for table [film_text]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_text_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_text_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_text_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_text_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_film_text_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_film_text_Update]
GO

--This SQL is generated for internal stored procedures for table [inventory]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_inventory_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_inventory_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_inventory_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_inventory_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_inventory_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_inventory_Update]
GO

--This SQL is generated for internal stored procedures for table [language]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_language_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_language_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_language_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_language_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_language_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_language_Update]
GO

--This SQL is generated for internal stored procedures for table [payment]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_payment_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_payment_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_payment_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_payment_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_payment_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_payment_Update]
GO

--This SQL is generated for internal stored procedures for table [rental]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_rental_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_rental_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_rental_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_rental_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_rental_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_rental_Update]
GO

--This SQL is generated for internal stored procedures for table [staff]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_staff_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_staff_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_staff_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_staff_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_staff_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_staff_Update]
GO

--This SQL is generated for internal stored procedures for table [store]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_store_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_store_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_store_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_store_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_store_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_store_Update]
GO

--##SECTION END [INTERNAL STORED PROCS]

